/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Version : 50173
 Source Host           : localhost
 Source Database       : db_iutils

 Target Server Version : 50173
 File Encoding         : utf-8

 Date: 01/03/2018 17:05:50 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `sys_config`
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `id` varchar(64) NOT NULL COMMENT '编号',
  `sys_name` varchar(255) NOT NULL COMMENT '系统名称',
  `module_name` varchar(255) NOT NULL COMMENT '模块名称',
  `config_name` varchar(255) NOT NULL COMMENT '配置key',
  `config_value` varchar(255) DEFAULT NULL COMMENT '配置值',
  `create_by` varchar(64) DEFAULT NULL COMMENT '创建人',
  `create_date` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT NULL COMMENT '修改人',
  `update_date` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` char(1) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='公共配置表';

-- ----------------------------
--  Records of `sys_config`
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` VALUES ('1', 'sys', 'common', 'project.name', '程序员工具', '1', '2017-05-16 14:33:01', '1', '2017-05-16 15:10:25', '项目名称（注：系统配置，不可删）', '0'), ('2', 'sys', 'common', 'project.copyright', '©2017 程序员工具 开源平台工具', '1', '2017-05-16 14:46:29', '1', '2017-05-16 15:10:36', '版权信息（注：系统配置，不可删）', '0'), ('3', 'sys', 'common', 'project.version', 'V3.0', '1', '2017-05-16 14:46:29', '1', '2017-05-16 14:46:29', '版本信息（注：系统配置，不可删）', '0');
COMMIT;

-- ----------------------------
--  Table structure for `sys_msg_receive`
-- ----------------------------
DROP TABLE IF EXISTS `sys_msg_receive`;
CREATE TABLE `sys_msg_receive` (
  `id` varchar(64) NOT NULL COMMENT '编号',
  `msg_id` varchar(64) NOT NULL COMMENT '消息编号',
  `update_by` varchar(64) NOT NULL COMMENT '接收人',
  `update_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '接收时间',
  `status` char(1) DEFAULT NULL COMMENT '状态 0未读 1已读',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='消息接收表';

-- ----------------------------
--  Records of `sys_msg_receive`
-- ----------------------------
BEGIN;
INSERT INTO `sys_msg_receive` VALUES ('11', '10', '1', '2017-04-12 14:00:23', '0'), ('12', '11', '1', '2017-12-20 14:21:30', '1'), ('14', '13', '1', '2017-12-20 14:18:59', '1'), ('26312d27edb348dc957bd1e2a35c1e2d', '426e4adcf42a4e199f2b0c286c482b56', '0a5ac6896dab4503adf8cbf70b688a63', '2017-12-20 17:18:01', '0');
COMMIT;

-- ----------------------------
--  Table structure for `sys_msg_send`
-- ----------------------------
DROP TABLE IF EXISTS `sys_msg_send`;
CREATE TABLE `sys_msg_send` (
  `id` varchar(64) NOT NULL COMMENT '编号',
  `type` varchar(50) NOT NULL COMMENT '消息类型  系统通知  站内信',
  `title` varchar(255) NOT NULL COMMENT '标题',
  `content` text NOT NULL COMMENT '内容',
  `levels` int(1) DEFAULT NULL COMMENT '重要级别',
  `users` varchar(5000) NOT NULL COMMENT '接收人',
  `create_by` varchar(64) DEFAULT NULL COMMENT '发送人',
  `create_date` timestamp NULL DEFAULT NULL COMMENT '发送时间',
  `status` char(1) DEFAULT NULL COMMENT '状态 0草稿 1已发送',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='消息发送表';

-- ----------------------------
--  Records of `sys_msg_send`
-- ----------------------------
BEGIN;
INSERT INTO `sys_msg_send` VALUES ('10', 'mail', '测试邮件', '                                                                                        \r\n                                        <p>测试邮件</p><p><br></p>\r\n                                        ', '0', '1,', '1', '2017-04-12 14:00:14', '1'), ('11', 'mail', '你好，我是管理员，现在测试站内信', '                                            \r\n                                        <p>你好，我是管理员，现在测试站内信</p><p><br></p>', '0', '1,', '1', '2017-04-12 16:00:09', '1'), ('13', 'mail', '消息', '                                            \r\n                                        <p>是多少</p>', '0', '1,', '1', '2017-04-12 16:10:27', '1'), ('426e4adcf42a4e199f2b0c286c482b56', 'mail', '张三，你有的信息到了', '                                                        \r\n                        <p>张三，你妈妈喊你回家吃饭</p>\r\n                        ', '0', '0a5ac6896dab4503adf8cbf70b688a63,', '1', '2017-12-20 17:17:56', '1');
COMMIT;

-- ----------------------------
--  Table structure for `sys_organization`
-- ----------------------------
DROP TABLE IF EXISTS `sys_organization`;
CREATE TABLE `sys_organization` (
  `id` varchar(64) NOT NULL COMMENT '编号',
  `name` varchar(100) DEFAULT NULL COMMENT '组织机构名称',
  `parent_id` varchar(64) DEFAULT NULL COMMENT '父编号',
  `parent_ids` varchar(5000) DEFAULT NULL COMMENT '父编号列表',
  `available` tinyint(1) DEFAULT '0' COMMENT '是否可用',
  `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
  `create_date` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT NULL COMMENT '修改者',
  `update_date` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  `remarks` varchar(225) DEFAULT NULL COMMENT '备注',
  `status` char(1) DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `idx_sys_organization_parent_id` (`parent_id`),
  KEY `idx_sys_organization_parent_ids` (`parent_ids`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='组织机构';

-- ----------------------------
--  Records of `sys_organization`
-- ----------------------------
BEGIN;
INSERT INTO `sys_organization` VALUES ('1', '组织机构', '0', '0/', '1', null, null, '1', '2016-09-25 20:56:43', null, '0'), ('2', '某某公司', '1', '0/1/', '1', '1', '2017-02-18 18:12:43', null, null, null, '0'), ('4', '某某部门', '2', '0/1/2/', '1', '1', '2017-04-10 16:16:51', '1', '2017-04-10 16:17:00', null, '0');
COMMIT;

-- ----------------------------
--  Table structure for `sys_resource`
-- ----------------------------
DROP TABLE IF EXISTS `sys_resource`;
CREATE TABLE `sys_resource` (
  `id` varchar(64) NOT NULL COMMENT '编号',
  `name` varchar(100) DEFAULT NULL COMMENT '资源名称',
  `type` varchar(50) DEFAULT NULL COMMENT '资源类型',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `url` varchar(200) DEFAULT NULL COMMENT '资源路径',
  `parent_id` varchar(64) DEFAULT NULL COMMENT '父编号',
  `parent_ids` varchar(5000) DEFAULT NULL COMMENT '父编号列表',
  `permission` varchar(100) DEFAULT NULL COMMENT '权限字符串',
  `is_sub` int(1) DEFAULT '0' COMMENT '是否有下级',
  `available` int(1) DEFAULT '0' COMMENT '是否可用',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
  `create_date` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT NULL COMMENT '修改者',
  `update_date` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  `remarks` varchar(225) DEFAULT NULL COMMENT '备注',
  `status` char(1) DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `idx_sys_resource_parent_id` (`parent_id`),
  KEY `idx_sys_resource_parent_ids` (`parent_ids`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='资源';

-- ----------------------------
--  Records of `sys_resource`
-- ----------------------------
BEGIN;
INSERT INTO `sys_resource` VALUES ('044a92264feb49f88d5c61f8ab4d96f1', '资源删除', 'form', '', 'resource/delete', 'c26a9b7be2374160a14e2afdcb6b6132', '0/8ba94f8e078340f6b19f9065071a274d/c26a9b7be2374160a14e2afdcb6b6132/', 'sys:resource:delete', '0', '1', '0', '1', '2017-12-21 10:20:40', null, null, null, '0'), ('081686bc52af46658da871f395c60d6c', '用户删除', 'form', '', 'user/delete', '6c2853436e3a4c3fbf73751d7f75b00f', '0/8ba94f8e078340f6b19f9065071a274d/6c2853436e3a4c3fbf73751d7f75b00f/', 'sys:user:delete', '0', '1', '0', '1', '2017-12-21 10:08:01', null, null, null, '0'), ('0a32242657914f988d3a5cae57f2da20', '机构新增', 'form', '', 'organization/create', '0a86ecb9afcb4a529f65691072d4192c', '0/8ba94f8e078340f6b19f9065071a274d/0a86ecb9afcb4a529f65691072d4192c/', 'sys:organization:create', '0', '1', '0', '1', '2017-12-21 10:23:35', null, null, null, '0'), ('0a86ecb9afcb4a529f65691072d4192c', '机构管理', 'menu', '', 'organization', '8ba94f8e078340f6b19f9065071a274d', '0/8ba94f8e078340f6b19f9065071a274d/', 'organization:menu', '0', '1', '3', '1', '2017-12-18 16:04:19', '1', '2017-12-21 10:56:01', null, '0'), ('0d974745086f4360924dba9a9e3033df', '任务删除', 'form', '', 'scheduleJob/delete', '5baeda3e1dca4a9297b385de2a29465d', '0/8ba94f8e078340f6b19f9065071a274d/5baeda3e1dca4a9297b385de2a29465d/', 'sys:scheduleJob:delete', '0', '1', '0', '1', '2017-12-21 10:32:45', null, null, null, '0'), ('0f344e0185d24ca5bac64c99b4a68b39', '查看资源列表', 'form', '', 'resource', 'c26a9b7be2374160a14e2afdcb6b6132', '0/8ba94f8e078340f6b19f9065071a274d/c26a9b7be2374160a14e2afdcb6b6132/', 'sys:resource:view', '0', '1', '0', '1', '2017-12-21 10:17:44', null, null, null, '0'), ('1b8d22e1833c432db6b04b985d797691', '配置编辑', 'form', '', 'config/update', 'e341851466b64e6197e691c557bee04f', '0/8ba94f8e078340f6b19f9065071a274d/e341851466b64e6197e691c557bee04f/', 'sys:config:update', '0', '1', '0', '1', '2017-12-21 10:41:29', null, null, null, '0'), ('20aa1402ef674390b99d7a12238dc5f0', '系统日志', 'menu', '', 'slog', '8ba94f8e078340f6b19f9065071a274d', '0/8ba94f8e078340f6b19f9065071a274d/', 'slog:menu', '0', '1', '7', '1', '2017-12-18 16:05:48', '1', '2017-12-21 10:56:32', null, '0'), ('2526b55fa5d649b5bfcb1867e79497e9', '查看会话列表', 'form', '', 'session', '784985766f65404dab878b226bfd176f', '0/8ba94f8e078340f6b19f9065071a274d/784985766f65404dab878b226bfd176f/', 'sys:session:view', '0', '1', '0', '1', '2017-12-21 10:27:39', '1', '2017-12-21 10:28:01', null, '0'), ('2828469fa48549f2bc0eb94fcb34ef69', '查看任务列表', 'form', '', 'scheduleJob', '5baeda3e1dca4a9297b385de2a29465d', '0/8ba94f8e078340f6b19f9065071a274d/5baeda3e1dca4a9297b385de2a29465d/', 'sys:scheduleJob:view', '0', '1', '0', '1', '2017-12-21 10:30:49', null, null, null, '0'), ('287ae61e836b428e8788816fee86eeff', '查看邮件内容', 'form', '', 'msgReceive/update', 'be1081470f23464bb7d95517fc605a7c', '0/be1081470f23464bb7d95517fc605a7c/', 'msgReceive:view', '0', '1', '0', '1', '2017-12-20 17:34:32', '1', '2017-12-21 10:00:21', null, '0'), ('2b4b888bdf484c9cbe5176a99238b3ce', '用户选择', 'form', '', 'user/selectUser', '6c2853436e3a4c3fbf73751d7f75b00f', '0/8ba94f8e078340f6b19f9065071a274d/6c2853436e3a4c3fbf73751d7f75b00f/', 'sys:user:view', '0', '1', '0', '1', '2017-12-21 10:14:42', null, null, null, '0'), ('2eea2a4dffc74e12903dcf88077d54c7', '查看收件箱列表', 'form', '', 'msgReceive', 'be1081470f23464bb7d95517fc605a7c', '0/be1081470f23464bb7d95517fc605a7c/', 'msgReceive:view', '0', '1', '0', '1', '2017-12-20 17:32:59', '1', '2017-12-21 10:00:06', null, '0'), ('36387f0446ae439192fbaeeda56e4730', '角色新增/编辑', 'form', '', 'role/update', 'cf2cb528c5a142468a5458732f85221e', '0/8ba94f8e078340f6b19f9065071a274d/cf2cb528c5a142468a5458732f85221e/', 'sys:role:edit', '0', '1', '0', '1', '2017-12-21 10:26:29', null, null, null, '0'), ('3a244c43304e4aa68c947fcc4ca6da93', ' 查看日志列表', 'form', '', 'slog', '20aa1402ef674390b99d7a12238dc5f0', '0/8ba94f8e078340f6b19f9065071a274d/20aa1402ef674390b99d7a12238dc5f0/', 'sys:slog:view', '0', '1', '0', '1', '2017-12-21 10:35:51', null, null, null, '0'), ('40418e1230274149acee47f74e704042', '任务编辑', 'form', '', 'scheduleJob/update', '5baeda3e1dca4a9297b385de2a29465d', '0/8ba94f8e078340f6b19f9065071a274d/5baeda3e1dca4a9297b385de2a29465d/', 'sys:scheduleJob:update', '0', '1', '0', '1', '2017-12-21 10:32:00', null, null, null, '0'), ('43e8a3f393274d9daa67b45421846721', '发送邮件', 'form', '', 'msgSend/send', 'be1081470f23464bb7d95517fc605a7c', '0/be1081470f23464bb7d95517fc605a7c/', 'msgSend:create', '0', '1', '0', '1', '2017-12-20 17:36:32', '1', '2017-12-20 17:36:41', null, '0'), ('471b26f1756c409aa04d2da24758f0a1', '机构删除', 'form', '', 'organization/delete', '0a86ecb9afcb4a529f65691072d4192c', '0/8ba94f8e078340f6b19f9065071a274d/0a86ecb9afcb4a529f65691072d4192c/', 'sys:organization:delete', '0', '1', '0', '1', '2017-12-21 10:25:05', null, null, null, '0'), ('4cf888d7b07d480fb4732459fdef0355', '用户新增', 'form', '', 'user/create', '6c2853436e3a4c3fbf73751d7f75b00f', '0/8ba94f8e078340f6b19f9065071a274d/6c2853436e3a4c3fbf73751d7f75b00f/', 'sys:user:create', '0', '1', '0', '1', '2017-12-21 10:07:08', null, null, null, '0'), ('52a66433d2f94be2b2c166509143ecdb', '配置新增', 'form', '', 'config/create', 'e341851466b64e6197e691c557bee04f', '0/8ba94f8e078340f6b19f9065071a274d/e341851466b64e6197e691c557bee04f/', 'sys:config:create', '0', '1', '0', '1', '2017-12-21 10:41:06', null, null, null, '0'), ('570d03bc07b447c5b1bb98d06a5b3eb5', '资源新增', 'form', '', 'resource/create', 'c26a9b7be2374160a14e2afdcb6b6132', '0/8ba94f8e078340f6b19f9065071a274d/c26a9b7be2374160a14e2afdcb6b6132/', 'sys:resource:create', '0', '1', '0', '1', '2017-12-21 10:19:23', null, null, null, '0'), ('5baeda3e1dca4a9297b385de2a29465d', '任务调度', 'menu', '', 'scheduleJob', '8ba94f8e078340f6b19f9065071a274d', '0/8ba94f8e078340f6b19f9065071a274d/', 'scheduleJob:menu', '0', '1', '6', '1', '2017-12-18 16:05:34', '1', '2017-12-21 10:56:25', null, '0'), ('6128b52b80e5474bb1fc9d4f9ba4d30a', '批量删除日志', 'form', '', 'slog/delete', '20aa1402ef674390b99d7a12238dc5f0', '0/8ba94f8e078340f6b19f9065071a274d/20aa1402ef674390b99d7a12238dc5f0/', 'sys:slog:delete', '0', '1', '0', '1', '2017-12-21 10:37:03', null, null, null, '0'), ('679d2d8135e24a1fa7593393f520822e', '修改密码', 'form', '', 'user/changePassword', '6c2853436e3a4c3fbf73751d7f75b00f', '0/8ba94f8e078340f6b19f9065071a274d/6c2853436e3a4c3fbf73751d7f75b00f/', 'sys:user:changePassword', '0', '1', '0', '1', '2017-12-21 10:08:48', '1', '2017-12-21 10:51:38', null, '0'), ('68196ddf44664cbb80512a0a565aa744', '查看日志详细', 'form', '', 'slog/update', '20aa1402ef674390b99d7a12238dc5f0', '0/8ba94f8e078340f6b19f9065071a274d/20aa1402ef674390b99d7a12238dc5f0/', 'sys:slog:view', '0', '1', '0', '1', '2017-12-21 10:36:31', null, null, null, '0'), ('6c2853436e3a4c3fbf73751d7f75b00f', '用户管理', 'menu', '', 'user', '8ba94f8e078340f6b19f9065071a274d', '0/8ba94f8e078340f6b19f9065071a274d/', 'user:menu', '0', '1', '1', '1', '2017-12-18 16:02:55', '1', '2017-12-21 10:55:29', null, '0'), ('73396932f67d4de38f25e06159dccacf', '保存草稿', 'form', '', 'msgSend/save', 'be1081470f23464bb7d95517fc605a7c', '0/be1081470f23464bb7d95517fc605a7c/', 'msgSend:create', '0', '1', '0', '1', '2017-12-20 17:38:37', null, null, null, '0'), ('784985766f65404dab878b226bfd176f', '会话管理', 'menu', '', 'session', '8ba94f8e078340f6b19f9065071a274d', '0/8ba94f8e078340f6b19f9065071a274d/', 'session:menu', '0', '1', '5', '1', '2017-12-18 16:05:12', '1', '2017-12-21 10:56:14', null, '0'), ('7f907fa79a8044bda81e00f4aca16f6b', '查看机构列表', 'form', '', 'organization', '0a86ecb9afcb4a529f65691072d4192c', '0/8ba94f8e078340f6b19f9065071a274d/0a86ecb9afcb4a529f65691072d4192c/', 'sys:organization:view', '0', '1', '0', '1', '2017-12-21 10:21:15', null, null, null, '0'), ('876a852a808545e881b452f0ea58ee8f', '立即执行任务', 'form', '', 'scheduleJob/runAJobNow', '5baeda3e1dca4a9297b385de2a29465d', '0/8ba94f8e078340f6b19f9065071a274d/5baeda3e1dca4a9297b385de2a29465d/', 'sys:scheduleJob:changeJobStatus', '0', '1', '0', '1', '2017-12-21 10:34:59', null, null, null, '0'), ('8a3948b38f9b45c18c5a9084231ba822', '查看用户信息', 'form', '', 'userInfo', '6c2853436e3a4c3fbf73751d7f75b00f', '0/8ba94f8e078340f6b19f9065071a274d/6c2853436e3a4c3fbf73751d7f75b00f/', 'sys:user:userInfo', '0', '1', '0', '1', '2017-12-21 10:10:45', '1', '2017-12-21 10:51:59', null, '0'), ('8ba94f8e078340f6b19f9065071a274d', '系统管理', 'menu', 'am-icon-cog', '', '0', '0/', 'sys:menu', '1', '1', '1', '1', '2017-12-13 17:20:04', '1', '2017-12-21 11:09:52', null, '0'), ('8bbf7cc114dd497c8f769b0df7f6b5bf', '角色删除', 'form', '', 'role/delete', 'cf2cb528c5a142468a5458732f85221e', '0/8ba94f8e078340f6b19f9065071a274d/cf2cb528c5a142468a5458732f85221e/', 'sys:role:delete', '0', '1', '0', '1', '2017-12-21 10:26:56', null, null, null, '0'), ('8f197660e6d646958bffc8806169ff26', '查看配置列表', 'form', '', 'config', 'e341851466b64e6197e691c557bee04f', '0/8ba94f8e078340f6b19f9065071a274d/e341851466b64e6197e691c557bee04f/', 'sys:config:view', '0', '1', '0', '1', '2017-12-21 10:37:37', null, null, null, '0'), ('90786a1e875543aba6733405900f53a1', '保存用户信息', 'form', '', 'user/saveUserInfo', '6c2853436e3a4c3fbf73751d7f75b00f', '0/8ba94f8e078340f6b19f9065071a274d/6c2853436e3a4c3fbf73751d7f75b00f/', 'sys:user:saveUserInfo', '0', '1', '0', '1', '2017-12-21 10:11:28', '1', '2017-12-21 10:52:08', null, '0'), ('907b4a28c9ef444991b1815978c9ad33', '收件箱通知', 'form', '', 'msgReceive/notice', 'be1081470f23464bb7d95517fc605a7c', '0/be1081470f23464bb7d95517fc605a7c/', 'msgReceive:notice', '0', '1', '0', '1', '2017-12-20 17:28:52', null, null, null, '0'), ('a68bd898f23a466ebab0933f9fb2ac07', '查看用户列表', 'form', '', 'user', '6c2853436e3a4c3fbf73751d7f75b00f', '0/8ba94f8e078340f6b19f9065071a274d/6c2853436e3a4c3fbf73751d7f75b00f/', 'sys:user:view', '0', '1', '0', '1', '2017-12-21 10:03:48', null, null, null, '0'), ('a6f2558d1cc3465aa9462a3cdefee023', '恢复任务', 'form', '', 'scheduleJob/resumeJob', '5baeda3e1dca4a9297b385de2a29465d', '0/8ba94f8e078340f6b19f9065071a274d/5baeda3e1dca4a9297b385de2a29465d/', 'sys:scheduleJob:changeJobStatus', '0', '1', '0', '1', '2017-12-21 10:34:35', null, null, null, '0'), ('abdacad7a2424d2dbb72ef44f91f37b2', '任务创建', 'form', '', 'scheduleJob/create', '5baeda3e1dca4a9297b385de2a29465d', '0/8ba94f8e078340f6b19f9065071a274d/5baeda3e1dca4a9297b385de2a29465d/', 'sys:scheduleJob:create', '0', '1', '0', '1', '2017-12-21 10:31:21', '1', '2017-12-21 10:32:06', null, '0'), ('b15046e1b7d7419cbcb4d1225ebf2dfa', '查看角色列表', 'form', '', 'role', 'cf2cb528c5a142468a5458732f85221e', '0/8ba94f8e078340f6b19f9065071a274d/cf2cb528c5a142468a5458732f85221e/', 'sys:role:view', '0', '1', '0', '1', '2017-12-21 10:25:40', null, null, null, '0'), ('b3dc372c2eed47be8772ec024228f09c', '机构编辑', 'form', '', 'organization/update', '0a86ecb9afcb4a529f65691072d4192c', '0/8ba94f8e078340f6b19f9065071a274d/0a86ecb9afcb4a529f65691072d4192c/', 'sys:organization:edit', '0', '1', '0', '1', '2017-12-21 10:24:43', null, null, null, '0'), ('be1081470f23464bb7d95517fc605a7c', '收件箱', 'menu', '', '', '0', '0/', 'msg:menu', '0', '0', '99', '1', '2017-12-18 16:07:39', '1', '2017-12-21 11:10:06', null, '0'), ('c0d4356804864e93af71373dd25ec2b5', '资源编辑', 'form', '', 'resource/update', 'c26a9b7be2374160a14e2afdcb6b6132', '0/8ba94f8e078340f6b19f9065071a274d/c26a9b7be2374160a14e2afdcb6b6132/', 'sys:resource:edit', '0', '1', '0', '1', '2017-12-21 10:20:03', null, null, null, '0'), ('c26a9b7be2374160a14e2afdcb6b6132', '资源管理', 'menu', '', 'resource', '8ba94f8e078340f6b19f9065071a274d', '0/8ba94f8e078340f6b19f9065071a274d/', 'resource:menu', '0', '1', '2', '1', '2017-12-18 16:03:11', '1', '2017-12-21 10:55:43', null, '0'), ('c2df67ebe6ff4a009110cf2905633e73', '资源树', 'form', '', 'resource/tree', 'c26a9b7be2374160a14e2afdcb6b6132', '0/8ba94f8e078340f6b19f9065071a274d/c26a9b7be2374160a14e2afdcb6b6132/', 'sys:resource:view', '0', '1', '0', '1', '2017-12-21 10:18:27', null, null, null, '0'), ('cb29bfa7ca6a470ebf2efa0055863dde', '更改任务状态', 'form', '', 'scheduleJob/changeJobStatus', '5baeda3e1dca4a9297b385de2a29465d', '0/8ba94f8e078340f6b19f9065071a274d/5baeda3e1dca4a9297b385de2a29465d/', 'sys:scheduleJob:changeJobStatus', '0', '1', '0', '1', '2017-12-21 10:33:28', null, null, null, '0'), ('ce3939113b1a4ec0b89385dfc94139d9', '配置删除', 'form', '', 'config/delete', 'e341851466b64e6197e691c557bee04f', '0/8ba94f8e078340f6b19f9065071a274d/e341851466b64e6197e691c557bee04f/', 'sys:config:delete', '0', '1', '0', '1', '2017-12-21 10:42:03', null, null, null, '0'), ('ce7f12dba6c34dfab10390cc2c327862', '删除收件箱', 'form', '', 'msgReceive/delete', 'be1081470f23464bb7d95517fc605a7c', '0/be1081470f23464bb7d95517fc605a7c/', 'msgReceive:delete', '0', '1', '0', '1', '2017-12-20 17:35:21', '1', '2017-12-21 09:57:08', null, '0'), ('cf2cb528c5a142468a5458732f85221e', '角色管理', 'menu', '', 'role', '8ba94f8e078340f6b19f9065071a274d', '0/8ba94f8e078340f6b19f9065071a274d/', 'role:menu', '0', '1', '4', '1', '2017-12-18 16:04:35', '1', '2017-12-21 10:56:08', null, '0'), ('d99a938137bc460f8731accdb5f0621a', '重置密码', 'form', '', 'user/resetPassword', '6c2853436e3a4c3fbf73751d7f75b00f', '0/8ba94f8e078340f6b19f9065071a274d/6c2853436e3a4c3fbf73751d7f75b00f/', 'sys:user:reset', '0', '1', '0', '1', '2017-12-21 10:10:03', null, null, null, '0'), ('dc2ccdb2146f4ab5b480265ef70cd8c3', '查看发件箱列表', 'form', '', 'msgSend', 'be1081470f23464bb7d95517fc605a7c', '0/be1081470f23464bb7d95517fc605a7c/', 'msgSend:view', '0', '1', '0', '1', '2017-12-20 17:38:03', '1', '2017-12-21 10:00:37', null, '0'), ('e26ba76620f743c79a68c8920431e83b', '接口-获取用户列表', 'form', '', 'user/getUsers', '6c2853436e3a4c3fbf73751d7f75b00f', '0/8ba94f8e078340f6b19f9065071a274d/6c2853436e3a4c3fbf73751d7f75b00f/', 'sys:user:view', '0', '1', '0', '1', '2017-12-21 10:15:26', null, null, null, '0'), ('e341851466b64e6197e691c557bee04f', '公共配置', 'menu', '', 'config', '8ba94f8e078340f6b19f9065071a274d', '0/8ba94f8e078340f6b19f9065071a274d/', 'config:menu', '0', '1', '8', '1', '2017-12-18 16:06:04', '1', '2017-12-21 10:56:40', null, '0'), ('e5f7685871874c759c339842b8d63a4e', '强制注销', 'form', '', 'session/forceLogout', '784985766f65404dab878b226bfd176f', '0/8ba94f8e078340f6b19f9065071a274d/784985766f65404dab878b226bfd176f/', 'sys:session:forceLogout', '0', '1', '0', '1', '2017-12-21 10:28:48', null, null, null, '0'), ('fdfa691938d04d4aab9f1e9bc041134b', '删除发件箱', 'form', '', 'msgSend/delete', 'be1081470f23464bb7d95517fc605a7c', '0/be1081470f23464bb7d95517fc605a7c/', 'msgSend:delete', '0', '1', '0', '1', '2017-12-20 17:39:21', '1', '2017-12-21 09:57:00', null, '0'), ('fed5e3cad52f4e4e8d56116be3ed7145', '暂停任务', 'form', '', 'scheduleJob/pauseJob', '5baeda3e1dca4a9297b385de2a29465d', '0/8ba94f8e078340f6b19f9065071a274d/5baeda3e1dca4a9297b385de2a29465d/', 'sys:scheduleJob:changeJobStatus', '0', '1', '0', '1', '2017-12-21 10:34:10', null, null, null, '0'), ('ff1ead2d8f9f49168a885f3c3ddbe500', '用户编辑', 'form', '', 'user/update', '6c2853436e3a4c3fbf73751d7f75b00f', '0/8ba94f8e078340f6b19f9065071a274d/6c2853436e3a4c3fbf73751d7f75b00f/', 'sys:user:update', '0', '1', '0', '1', '2017-12-21 10:07:37', null, null, null, '0');
COMMIT;

-- ----------------------------
--  Table structure for `sys_role`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` varchar(64) NOT NULL COMMENT '权限编号',
  `role` varchar(100) DEFAULT NULL COMMENT '角色标识',
  `name` varchar(100) NOT NULL COMMENT '角色名称',
  `organization_id` varchar(64) NOT NULL COMMENT '归属机构',
  `resource_ids` text COMMENT '资源编号集合',
  `data_scope` varchar(50) NOT NULL COMMENT '数据范围',
  `available` tinyint(1) DEFAULT '0' COMMENT '是否可用',
  `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
  `create_date` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT NULL COMMENT '修改者',
  `update_date` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  `remarks` varchar(225) DEFAULT NULL COMMENT '备注',
  `status` char(1) DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='权限';

-- ----------------------------
--  Records of `sys_role`
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('1', 'super', '超级管理员', '1', '8ba94f8e078340f6b19f9065071a274d,fdfa691938d04d4aab9f1e9bc041134b,081686bc52af46658da871f395c60d6c,2b4b888bdf484c9cbe5176a99238b3ce,4cf888d7b07d480fb4732459fdef0355,679d2d8135e24a1fa7593393f520822e,8a3948b38f9b45c18c5a9084231ba822,90786a1e875543aba6733405900f53a1,a68bd898f23a466ebab0933f9fb2ac07,d99a938137bc460f8731accdb5f0621a,e26ba76620f743c79a68c8920431e83b,ff1ead2d8f9f49168a885f3c3ddbe500,c26a9b7be2374160a14e2afdcb6b6132,044a92264feb49f88d5c61f8ab4d96f1,0f344e0185d24ca5bac64c99b4a68b39,570d03bc07b447c5b1bb98d06a5b3eb5,c0d4356804864e93af71373dd25ec2b5,c2df67ebe6ff4a009110cf2905633e73,0a86ecb9afcb4a529f65691072d4192c,0a32242657914f988d3a5cae57f2da20,471b26f1756c409aa04d2da24758f0a1,7f907fa79a8044bda81e00f4aca16f6b,b3dc372c2eed47be8772ec024228f09c,cf2cb528c5a142468a5458732f85221e,36387f0446ae439192fbaeeda56e4730,8bbf7cc114dd497c8f769b0df7f6b5bf,b15046e1b7d7419cbcb4d1225ebf2dfa,784985766f65404dab878b226bfd176f,6c2853436e3a4c3fbf73751d7f75b00f,e5f7685871874c759c339842b8d63a4e,5baeda3e1dca4a9297b385de2a29465d,0d974745086f4360924dba9a9e3033df,2828469fa48549f2bc0eb94fcb34ef69,40418e1230274149acee47f74e704042,876a852a808545e881b452f0ea58ee8f,a6f2558d1cc3465aa9462a3cdefee023,abdacad7a2424d2dbb72ef44f91f37b2,cb29bfa7ca6a470ebf2efa0055863dde,fed5e3cad52f4e4e8d56116be3ed7145,20aa1402ef674390b99d7a12238dc5f0,3a244c43304e4aa68c947fcc4ca6da93,6128b52b80e5474bb1fc9d4f9ba4d30a,68196ddf44664cbb80512a0a565aa744,e341851466b64e6197e691c557bee04f,1b8d22e1833c432db6b04b985d797691,52a66433d2f94be2b2c166509143ecdb,8f197660e6d646958bffc8806169ff26,ce3939113b1a4ec0b89385dfc94139d9,be1081470f23464bb7d95517fc605a7c,287ae61e836b428e8788816fee86eeff,2eea2a4dffc74e12903dcf88077d54c7,43e8a3f393274d9daa67b45421846721,73396932f67d4de38f25e06159dccacf,907b4a28c9ef444991b1815978c9ad33,ce7f12dba6c34dfab10390cc2c327862,dc2ccdb2146f4ab5b480265ef70cd8c3,2526b55fa5d649b5bfcb1867e79497e9,', 'self', '1', '1', '2016-10-08 12:32:47', '1', '2017-12-21 10:46:44', '至高权限', '0'), ('2', 'user', '普通用户', '1', '679d2d8135e24a1fa7593393f520822e,8a3948b38f9b45c18c5a9084231ba822,90786a1e875543aba6733405900f53a1,784985766f65404dab878b226bfd176f,2526b55fa5d649b5bfcb1867e79497e9,', 'self', '1', '1', '2017-04-10 16:18:11', '1', '2017-12-21 11:09:12', '', '0');
COMMIT;

-- ----------------------------
--  Table structure for `sys_schedule_job`
-- ----------------------------
DROP TABLE IF EXISTS `sys_schedule_job`;
CREATE TABLE `sys_schedule_job` (
  `id` varchar(64) NOT NULL COMMENT '编号',
  `job_name` varchar(200) DEFAULT NULL COMMENT '任务名称',
  `job_group` varchar(200) DEFAULT NULL COMMENT '任务分组',
  `cron` varchar(200) DEFAULT NULL COMMENT 'cron表达式',
  `bean_class` varchar(500) DEFAULT NULL COMMENT '任务执行时调用哪个类的方法 包名+类名',
  `is_concurrent` char(1) DEFAULT NULL COMMENT '是否有状态',
  `method_name` varchar(200) DEFAULT NULL COMMENT '任务调用的方法名',
  `params` varchar(200) DEFAULT NULL COMMENT '初始化参数',
  `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
  `create_date` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT NULL COMMENT '修改者',
  `update_date` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  `remarks` varchar(200) DEFAULT NULL COMMENT '描述',
  `status` char(1) DEFAULT NULL COMMENT '任务状态 0禁用 1启用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='任务调度';

-- ----------------------------
--  Records of `sys_schedule_job`
-- ----------------------------
BEGIN;
INSERT INTO `sys_schedule_job` VALUES ('2', '日志记录', '日志', '0/30 * * * * ?', 'cn.iutils.task.TaskLog', '1', 'run',null, '1', '2016-07-19 13:28:42', '1', '2016-10-08 11:15:24', '30秒清理记录日志', '1'), ('3', '会话管理', '会话', '0 0/30 * * * ?', 'cn.iutils.task.TaskSysSession', '1', 'start',null, '1', '2017-03-26 14:10:09', '1', '2017-03-26 15:47:59', '可以被覆盖', '1');
COMMIT;

-- ----------------------------
--  Table structure for `sys_sessions`
-- ----------------------------
DROP TABLE IF EXISTS `sys_sessions`;
CREATE TABLE `sys_sessions` (
  `id` varchar(100) NOT NULL,
  `session_data` varchar(5000) DEFAULT NULL COMMENT 'session对象',
  `create_date` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sessions_index_id` (`id`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='session管理';

-- ----------------------------
--  Table structure for `sys_slog`
-- ----------------------------
DROP TABLE IF EXISTS `sys_slog`;
CREATE TABLE `sys_slog` (
  `id` varchar(64) NOT NULL COMMENT '编号',
  `menu` varchar(255) NOT NULL COMMENT '菜单',
  `remote_addr` varchar(50) NOT NULL COMMENT '操作IP',
  `request_uri` varchar(200) NOT NULL COMMENT '请求地址',
  `method` varchar(5) NOT NULL COMMENT '操作方式',
  `params` text COMMENT '提交的数据',
  `user_agent` varchar(500) DEFAULT NULL COMMENT '用户代理',
  `exceptions` text COMMENT '异常信息',
  `create_by` varchar(64) DEFAULT NULL COMMENT '记录人',
  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录时间',
  `time_consuming` varchar(50) NOT NULL COMMENT '耗时',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统日志';

-- ----------------------------
--  Table structure for `sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` varchar(64) NOT NULL COMMENT '主键',
  `no` varchar(100) DEFAULT NULL COMMENT '用户编号',
  `organization_id` varchar(64) NOT NULL COMMENT '机构编号',
  `username` varchar(100) NOT NULL COMMENT '账号',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `salt` varchar(100) DEFAULT NULL,
  `role_ids` varchar(100) DEFAULT NULL COMMENT '权限编号集合',
  `name` varchar(100) DEFAULT NULL COMMENT '姓名',
  `sex` varchar(5) DEFAULT NULL COMMENT '性别',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `id_card` varchar(100) DEFAULT NULL COMMENT '身份证',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(45) DEFAULT NULL COMMENT '电话号码',
  `mobile` varchar(45) DEFAULT NULL COMMENT '手机号码',
  `photo` varchar(1000) DEFAULT NULL COMMENT '头像',
  `login_ip` varchar(45) DEFAULT NULL COMMENT '登录IP',
  `login_date` datetime DEFAULT NULL COMMENT '登录时间',
  `locked` tinyint(1) DEFAULT '0' COMMENT '是否锁定',
  `is_dept` tinyint(1) DEFAULT NULL COMMENT '是否部门管理员',
  `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
  `create_date` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT NULL COMMENT '修改者',
  `update_date` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  `remarks` varchar(225) DEFAULT NULL COMMENT '备注',
  `status` char(1) DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_sys_user_username` (`username`),
  KEY `idx_sys_user_organization_id` (`organization_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户表';

-- ----------------------------
--  Records of `sys_user`
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('0a5ac6896dab4503adf8cbf70b688a63', '17122010001', '4', 'zhangsan', '20bdf02aa7a08b9887bacbc4f1c7f419', '2543602d190b835fdcf2f28d6221b6a7', '2,', '张三', 'man', '26', '', '', '', '', null, null, null, '0', '0', '1', '2017-12-20 11:07:31', '1', '2017-12-20 11:07:31', null, '0'), ('1', '17122010000', '1', 'super', 'ff7e419b2147a346fcf97e8a0d439143', '7b5f5d3a1d3ba80fed0ad6256eb0fc3c', '1,', '超级管理', 'man', '999', '', '', '', '', '', null, null, '0', '0', '1', '2016-10-15 17:13:38', '1', '2017-12-20 10:55:04', '', '0'), ('817c7bb0684241acb7bab767c19d51b3', '17122110001', '4', 'wangwu', '3183286085dc31a243b0183048615782', 'c1632bc1e3cde1e6ffa1c843e2cf8b91', '2,', '王五', 'man', '35', '', '', '', '', null, null, null, '0', '0', '1', '2017-12-21 15:44:09', '1', '2017-12-21 15:44:21', null, '0'), ('f0c4bd280de44485b8da3240f3820ed5', '17122010002', '4', 'lisi', '60b0eaf715a062150b5dd9916b3487da', 'ad5eb4dd7ad83cbf2fb4c415d1b81ebf', '2,', '李四', 'man', '32', '12', '1232123@126.com', '', '', '', null, null, '0', '0', '1', '2017-12-20 11:07:59', 'f0c4bd280de44485b8da3240f3820ed5', '2017-12-21 11:11:45', '', '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
